﻿

CREATE proc [dbo].[GetPostleitzahlOrt]
@EPLZ	int = null
as
begin
	set nocount on
	
	select	top 1
			p.EPLZ,
			p.LKZ,
			p.Ort,
			p.PLZ,
			p.Zone,
			p.Bundesland
	from	dbo.Postleitzahl p
	where	p.EPLZ = @EPLZ
				or @EPLZ is null
end
GO
GRANT EXECUTE
    ON OBJECT::[dbo].[GetPostleitzahlOrt] TO PUBLIC
    AS [dbo];

